Home   |   Technology   |   Screen Shots   |   Download   |   Documentation   |   History   |   For Developers

Search... Search For: Index... Centrallix Documentation 1. Getting Started 2. Applications Overview 3. Application Components 4. Reports Overview 5. Report Components 6. SQL Language 6.1 SELECT Statements 6.2 WHERE Clause 6.3 FROM Clause 6.4 ORDER BY Clause 6.5 GROUP BY Clause 6.6 HAVING Clause 6.7 Data Types 6.8 Functions and Operators 6.8.1 String Functions 6.8.2 Aggregate Functions 6.8.3 Domain Declaration Functions 6.8.4 Date and Time Functions 6.8.5 Conversion and Encoding Functions 6.8.6 Mathematical Functions 6.8.7 Cryptographic Functions 6.8.8 Other Functions 6.8.9 SQL Operators 6.9 Subqueries 6.10 INSERT Statements 6.11 UPDATE Statements 6.12 DELETE Statements 6.13 DECLARE Statements 6.14 EXEC Statements 7. Process Modeling 8. Application Modeling 9. Role-Based Security 10. Business Logic Modeling 11. Other Objects 12. External API's 13. Internal API's 6.8 Functions and Operators (0 comments) Functions and Operators Here is a summary of the functions and operators that Centrallix supports. Note that, generally, these functions and operators apply to both SQL expressions and the expressions found in application, component, and report definitions. A notation is given as to what SQL standard, if any, also uses the particular function. ANSI means the function or operator is nearly universal, unless otherwise noted (in some cases the ANSI standard is not followed by many SQLs). Operators Arithmetic operators: +, -, *, / Boolean operators: AND, OR, NOT NULL tests: IS NULL, IS NOT NULL Comparison operators: =, !=, <, >, <=, >=, *=, =* Attribute references: :attr, :obj:attr, ::attr For details, see SQL Operators. Functions Most functions return NULL if any of the required arguments is NULL. There are some exceptions to this, however. Not all functions are appropriate in all contexts. String Functions: ascii(), charindex(), char_length(), cos_compare(), escape(), lev_compare(), levenshtein(), lower(), ltrim(), lztrim(), quote(), ralign(), replace(), replicate(), reverse(), right(), rtrim(), substitute(), substring(), wordify(). Aggregate Functions: avg(), count(), first(), last(), nth(), max(), min(), sum(). Domain Declaration Functions: runclient(), runserver(), runstatic(). Date and Time Functions: dateadd(), datediff(), datepart(), getdate(). Conversion and Encoding Functions: convert(), dateformat(), from_base64(), from_hex(), to_base64(), to_hex(), wordify(). Mathematical Functions: abs(), acos(), asin(), atan(), atan2(), constrain(), cos(), degrees(), log10(), power(), radians(), rand(), round(), sin(), sqrt(), square(), tan(), truncate(). Cryptographic Functions: hash(), hmac(), pbkdf2(), argon2id(). Other Functions: condition(), dense_rank(), eval(), has_endorsement(), isnull(), lag(), nullif(), row_number(), user_name(). Comments... (none yet) Add a Comment... Your Name: Comment: (c) 2001-2020 LightSys Technology Services, Inc. All trademarks are property of their respective owners. Project Hosting Provided By: